/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : bidcms

Target Server Type    : MYSQL
Target Server Version : 50624
File Encoding         : 65001

Date: 2016-01-07 23:52:09
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`user_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`tel`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`province`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`postal_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`county`  varchar(323) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`city`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`area_code`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`address_detail`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `user_id` (`user_id`) USING BTREE ,
INDEX `user_id_2` (`user_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of address
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for attachment
-- ----------------------------
DROP TABLE IF EXISTS `attachment`;
CREATE TABLE `attachment` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`title`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`thumb_url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`media_type`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`created_time`  int(11) NOT NULL ,
`size`  int(11) NOT NULL ,
`width`  int(11) NOT NULL ,
`height`  int(11) NOT NULL ,
`goods_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE ,
INDEX `goods_id` (`goods_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=45

;

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`goods_id`  int(11) NOT NULL ,
`goods_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`image_url`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`sku_id`  int(11) NOT NULL ,
`sku_info`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`price`  float NOT NULL ,
`num`  int(11) NOT NULL ,
`use_wxpay`  tinyint(2) NOT NULL ,
`messages`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `goods_id` (`goods_id`, `sku_id`) USING BTREE ,
INDEX `user_id` (`user_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of cart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`province`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`city`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`area`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status`  tinyint(1) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `user_id` (`user_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of company
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for component
-- ----------------------------
DROP TABLE IF EXISTS `component`;
CREATE TABLE `component` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`title`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`alias`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`created_time`  int(11) NOT NULL ,
`is_default`  tinyint(2) NOT NULL ,
`apply_num`  int(11) NOT NULL ,
`apply_list`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`store_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Table structure for feature
-- ----------------------------
DROP TABLE IF EXISTS `feature`;
CREATE TABLE `feature` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`alias`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`title`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`num`  int(11) NOT NULL ,
`goods_num`  int(11) NOT NULL ,
`bro_uvpv`  int(20) NOT NULL ,
`shop_uvpv`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`created_time`  int(11) NOT NULL ,
`cate_id`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_display`  tinyint(1) NOT NULL ,
`description`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_homepage`  tinyint(1) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE ,
INDEX `is_display` (`is_display`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=45

;


-- ----------------------------
-- Table structure for feature_class
-- ----------------------------
DROP TABLE IF EXISTS `feature_class`;
CREATE TABLE `feature_class` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`title`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`feature_count`  int(11) NOT NULL ,
`created_time`  int(11) NOT NULL ,
`alias`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_default`  tinyint(2) NOT NULL ,
`store_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=20

;

-- ----------------------------
-- Table structure for feight
-- ----------------------------
DROP TABLE IF EXISTS `feight`;
CREATE TABLE `feight` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pay_type`  tinyint(2) NOT NULL ,
`valuation_type`  tinyint(2) NOT NULL ,
`is_copy_of`  int(11) NOT NULL ,
`use_count`  int(11) NOT NULL ,
`last_modified`  int(11) NOT NULL ,
`region_rules`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`valuation_rules`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of feight
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`title`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`bro_puv`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`price`  float NOT NULL ,
`created_time`  int(11) NOT NULL ,
`tags`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`total_stock`  int(11) NOT NULL ,
`image_url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_display`  tinyint(1) NOT NULL ,
`sold_num`  int(11) NOT NULL ,
`stock_num`  int(11) NOT NULL ,
`num`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_virtual`  tinyint(1) NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`order_id`  mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT ,
`order_no`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`order_status`  varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  int(11) NOT NULL ,
`customer_id`  int(11) NOT NULL ,
`store_id`  int(11) NOT NULL ,
`postage`  float NOT NULL ,
`messages`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`add_time`  int(11) NOT NULL ,
`cancel_time`  int(11) NOT NULL ,
`expire_time`  int(11) NOT NULL ,
`refund_time`  int(11) NOT NULL ,
`goods_amount`  float NOT NULL ,
`save_amount`  float NOT NULL ,
`order_amount`  float NOT NULL ,
`consignee`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`address_id`  int(11) NOT NULL ,
`address_type`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`zipcode`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`tel`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_time`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`buy_way`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`remark`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`express_id`  tinyint(2) NOT NULL ,
`express_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`express_time`  int(11) NOT NULL ,
PRIMARY KEY (`order_id`),
UNIQUE INDEX `order_no` (`order_no`) USING BTREE ,
INDEX `user_id` (`user_id`) USING BTREE ,
INDEX `store_id` (`store_id`) USING BTREE ,
INDEX `customer_id` (`customer_id`) USING BTREE ,
INDEX `order_status` (`order_status`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for order_goods
-- ----------------------------
DROP TABLE IF EXISTS `order_goods`;
CREATE TABLE `order_goods` (
`order_id`  int(11) NOT NULL ,
`goods_id`  mediumint(8) UNSIGNED NOT NULL DEFAULT 0 ,
`sku_id`  int(11) NOT NULL ,
`sku_info`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`goods_name`  varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`image_url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`goods_sn`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`goods_number`  smallint(5) UNSIGNED NOT NULL DEFAULT 1 ,
`goods_price`  decimal(10,2) NOT NULL DEFAULT 0.00 ,
`is_virtual`  tinyint(1) NOT NULL ,
`express_id`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`express_no`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_express`  tinyint(1) NOT NULL ,
INDEX `goods_id` (`goods_id`) USING BTREE ,
INDEX `order_id` (`order_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of order_goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for order_log
-- ----------------------------
DROP TABLE IF EXISTS `order_log`;
CREATE TABLE `order_log` (
`order_id`  int(11) NOT NULL ,
`order_status`  tinyint(1) NOT NULL ,
`info`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`updatetime`  int(11) NOT NULL ,
`do_type`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`do_id`  int(11) NOT NULL ,
INDEX `order_id` (`order_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of order_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for selffetch_list
-- ----------------------------
DROP TABLE IF EXISTS `selffetch_list`;
CREATE TABLE `selffetch_list` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`tel`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`province`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`city`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`county`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`address_detail`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`dfcode`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of selffetch_list
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for session
-- ----------------------------
DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
`sessionid`  char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`lasttime`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`data`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
UNIQUE INDEX `sessionid` (`sessionid`) USING BTREE ,
INDEX `lasttime` (`lasttime`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of session
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for setting
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
`variable`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='系统设置表'

;

-- ----------------------------
-- Records of setting
-- ----------------------------
BEGIN;
INSERT INTO `setting` VALUES ('site_title', 'BidCms微信助手'), ('site_url', 'http://localhost'), ('site_title', 'BidCms微信助手'), ('site_url', 'http://localhost');
COMMIT;

-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`alias`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_id`  int(11) NOT NULL ,
`shop_name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`business`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`company_id`  int(11) NOT NULL ,
`contact_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`created_time`  int(11) NOT NULL ,
`total_score`  int(11) NOT NULL ,
`store_url`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status`  tinyint(2) NOT NULL ,
`score`  int(11) NOT NULL ,
`qq`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mobile`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`logo`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_lock`  tinyint(2) NOT NULL ,
`is_domain_set`  tinyint(2) NOT NULL ,
`intro`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`update_time`  int(11) NOT NULL ,
`weixin`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`certificate`  tinyint(2) NOT NULL ,
`cp_result`  tinyint(2) NOT NULL ,
`type`  tinyint(2) NOT NULL ,
`level`  int(11) NOT NULL ,
`flag`  tinyint(2) NOT NULL ,
`weibo`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mp_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
INDEX `user_id` (`user_id`) USING BTREE ,
INDEX `alias` (`alias`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of shop
-- ----------------------------
BEGIN;
INSERT INTO `shop` VALUES ('1', '1774b32e', '1', 'asd', '[{\"text\":\"3C\\u6570\\u7801\",\"value\":\"11\"}]', '0', 'cess', '1451127596', '0', '', '0', '0', '123456789', '13111111111', 'http://localhost/static/v2/image/shop.png', '4', '0', '', '1451135889', '', '0', '0', '0', '0', '0', '', '0');
COMMIT;

-- ----------------------------
-- Table structure for shop_user
-- ----------------------------
DROP TABLE IF EXISTS `shop_user`;
CREATE TABLE `shop_user` (
`uid`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`nickname`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`realname`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pwd`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`updatetime`  int(11) NOT NULL ,
`recommend`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`avatar`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`weixin`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`qq`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mobile`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`uid`),
INDEX `username` (`username`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of shop_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sms
-- ----------------------------
DROP TABLE IF EXISTS `sms`;
CREATE TABLE `sms` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`mobile`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`uid`  int(11) NOT NULL ,
`biz`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`token`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`code`  varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of sms
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tags
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`store_id`  int(11) NOT NULL ,
`title`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`alias`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`created_time`  int(11) NOT NULL ,
`is_delete`  tinyint(1) NOT NULL ,
`is_display`  tinyint(2) NOT NULL ,
`goods_count`  int(11) NOT NULL ,
`is_default`  tinyint(2) NOT NULL ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
INDEX `store_id` (`store_id`) USING BTREE 
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of tags
-- ----------------------------
BEGIN;
INSERT INTO `tags` VALUES ('1', '1', 'PC', 'eabb2b88', '1451576311', '0', '0', '0', '0', '');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`uid`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`nickname`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`realname`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pwd`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`updatetime`  int(11) NOT NULL ,
`recommend`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`avatar`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`weixin`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`kdtnote_fans_id`  int(11) NOT NULL ,
`sign`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`gender`  tinyint(2) NOT NULL ,
`qq`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mobile`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`sex`  tinyint(1) NOT NULL ,
`status`  tinyint(1) NOT NULL ,
PRIMARY KEY (`uid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'admin', '', '', '32f297a57a5a743894a0', '0', '', '', '', '0', '', '0', '', '', '0', '0'), ('2', 'admin', '', '', '32f297a57a5a743894a0', '0', '', '', '', '0', '', '0', '', '', '0', '0');
COMMIT;

-- ----------------------------
-- Auto increment value for address
-- ----------------------------
ALTER TABLE `address` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for attachment
-- ----------------------------
ALTER TABLE `attachment` AUTO_INCREMENT=45;

-- ----------------------------
-- Auto increment value for cart
-- ----------------------------
ALTER TABLE `cart` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for company
-- ----------------------------
ALTER TABLE `company` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for component
-- ----------------------------
ALTER TABLE `component` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for feature
-- ----------------------------
ALTER TABLE `feature` AUTO_INCREMENT=45;

-- ----------------------------
-- Auto increment value for feature_class
-- ----------------------------
ALTER TABLE `feature_class` AUTO_INCREMENT=20;

-- ----------------------------
-- Auto increment value for feight
-- ----------------------------
ALTER TABLE `feight` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for goods
-- ----------------------------
ALTER TABLE `goods` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for order
-- ----------------------------
ALTER TABLE `order` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for selffetch_list
-- ----------------------------
ALTER TABLE `selffetch_list` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for shop
-- ----------------------------
ALTER TABLE `shop` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for shop_user
-- ----------------------------
ALTER TABLE `shop_user` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for sms
-- ----------------------------
ALTER TABLE `sms` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for tags
-- ----------------------------
ALTER TABLE `tags` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for user
-- ----------------------------
ALTER TABLE `user` AUTO_INCREMENT=3;
